Copy Sheet
AutomatR.GoogleSheets.Activities.CopySheet
The "Copy Sheet" activity in AutomatR for Google Sheets facilitates the copying of a sheet from one spreadsheet and pasting it into the same spreadsheet or a different spreadsheet. This activity provides an efficient way to duplicate sheet content, whether within the same document or across different documents in Google Sheets.
Properties
| Name | Description |
|---|---|
| Input | |
| New Sheet Name | Specifies the name for the new sheet where the copied cells of the source sheet will be pasted. String variables containing the desired new sheet name. |
| Miscellaneous | |
| Display Name | Provides a customizable name for the activity displayed in the workflow. The display name enhances clarity and organization within the automation project. String variables containing the desired display name. |
| Optional | |
| Delay | Specifies the amount of time (in seconds) to wait before executing the "Copy Sheet" activity. This can be useful for handling synchronization issues. Integer variables containing the delay duration. Example: If the amount of time is 1000 milliseconds or 1 sec, i.e., 1. |
How to Use
- Drag and drop the "Copy Sheet" activity onto the workflow.
- Configure the properties by specifying the new sheet name for pasting the copied cells.
- Optionally, configure the delay and customize the display name.
- Execute the workflow to copy the sheet's content to the specified new sheet within the same or a different spreadsheet.
Example
Consider an example where the "Copy Sheet" activity is used to copy a sheet named "DataSheet" from the current spreadsheet to a new sheet named "DataBackup":
Copy Sheet:
Display Name: "Backup Data Sheet"
New Sheet Name: "DataBackup"
Delay: 2
In this example, the activity copies the contents of the "DataSheet" to a new sheet named "DataBackup." The delay is set to 2 seconds to allow for proper synchronization.